raw_data

Dataset statistics

Number of variables	18
Number of observations	22049
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	11.5 MiB
Average record size in memory	546.3 B

Variable types

Text	2
DateTime	1
Numeric	7
Categorical	7
Boolean	1

Alerts

`Total_Amount` is highly overall correlated with `Unit_Price`	High correlation
`Unit_Price` is highly overall correlated with `Total_Amount`	High correlation
`Order_ID` has unique values	Unique
`Discount_Amount` has 14046 (63.7%) zeros	Zeros

Reproduction

Analysis started	2026-02-20 16:16:24.528120
Analysis finished	2026-02-20 16:16:30.388267
Duration	5.86 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

Order_ID
Text

Unique

Distinct	22049
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

Length

Max length	13
Median length	12
Mean length	11.550728
Min length	10

Characters and Unicode

Total characters	254682
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	22049 ?
Unique (%)	100.0%

Sample

1st row	ORD_000902
2nd row	ORD_003209
3rd row	ORD_001404
4th row	ORD_000463
5th row	ORD_002934

Value	Count	Frequency (%)
ord_000902	1	< 0.1%
ord_001329-5	1	< 0.1%
ord_002934	1	< 0.1%
ord_001360	1	< 0.1%
ord_000841	1	< 0.1%
ord_001048	1	< 0.1%
ord_001051	1	< 0.1%
ord_003543	1	< 0.1%
ord_003371-8	1	< 0.1%
ord_004443	1	< 0.1%
Other values (22039)	22039	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	55159	21.7%
O	22049	8.7%
R	22049	8.7%
D	22049	8.7%
_	22049	8.7%
-	17049	6.7%
1	16163	6.3%
2	14947	5.9%
3	13932	5.5%
4	12956	5.1%
Other values (5)	36280	14.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	254682	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	55159	21.7%
O	22049	8.7%
R	22049	8.7%
D	22049	8.7%
_	22049	8.7%
-	17049	6.7%
1	16163	6.3%
2	14947	5.9%
3	13932	5.5%
4	12956	5.1%
Other values (5)	36280	14.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	254682	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	55159	21.7%
O	22049	8.7%
R	22049	8.7%
D	22049	8.7%
_	22049	8.7%
-	17049	6.7%
1	16163	6.3%
2	14947	5.9%
3	13932	5.5%
4	12956	5.1%
Other values (5)	36280	14.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	254682	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	55159	21.7%
O	22049	8.7%
R	22049	8.7%
D	22049	8.7%
_	22049	8.7%
-	17049	6.7%
1	16163	6.3%
2	14947	5.9%
3	13932	5.5%
4	12956	5.1%
Other values (5)	36280	14.2%

Customer_ID
Text

Distinct	5000
Distinct (%)	22.7%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	220490
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CUST_00902
2nd row	CUST_03209
3rd row	CUST_01404
4th row	CUST_00463
5th row	CUST_02934

Value	Count	Frequency (%)
cust_02572	11	< 0.1%
cust_00844	11	< 0.1%
cust_03285	11	< 0.1%
cust_03580	11	< 0.1%
cust_04179	11	< 0.1%
cust_01230	11	< 0.1%
cust_02765	11	< 0.1%
cust_02156	11	< 0.1%
cust_04378	11	< 0.1%
cust_01594	11	< 0.1%
Other values (4990)	21939	99.5%

Most occurring characters

Value	Count	Frequency (%)
0	33016	15.0%
C	22049	10.0%
U	22049	10.0%
S	22049	10.0%
T	22049	10.0%
_	22049	10.0%
4	11111	5.0%
3	11078	5.0%
1	11069	5.0%
2	10839	4.9%
Other values (5)	33132	15.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	220490	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	33016	15.0%
C	22049	10.0%
U	22049	10.0%
S	22049	10.0%
T	22049	10.0%
_	22049	10.0%
4	11111	5.0%
3	11078	5.0%
1	11069	5.0%
2	10839	4.9%
Other values (5)	33132	15.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	220490	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	33016	15.0%
C	22049	10.0%
U	22049	10.0%
S	22049	10.0%
T	22049	10.0%
_	22049	10.0%
4	11111	5.0%
3	11078	5.0%
1	11069	5.0%
2	10839	4.9%
Other values (5)	33132	15.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	220490	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	33016	15.0%
C	22049	10.0%
U	22049	10.0%
S	22049	10.0%
T	22049	10.0%
_	22049	10.0%
4	11111	5.0%
3	11078	5.0%
1	11069	5.0%
2	10839	4.9%
Other values (5)	33132	15.0%

Date
Date

Distinct	451
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	344.5 KiB

Minimum	2023-01-01 00:00:00
Maximum	2024-03-26 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Age
Real number (ℝ)

Distinct	57
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.965441

Minimum	18
Maximum	75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	344.5 KiB

Quantile statistics

Minimum	18
5-th percentile	18
Q1	27
median	35
Q3	42
95-th percentile	54
Maximum	75
Range	57
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.054313
Coefficient of variation (CV)	0.31614967
Kurtosis	-0.39394124
Mean	34.965441
Median Absolute Deviation (MAD)	8
Skewness	0.3239267
Sum	770953
Variance	122.19783
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	2058	9.3%
37	869	3.9%
34	795	3.6%
38	771	3.5%
32	769	3.5%
40	746	3.4%
35	730	3.3%
41	681	3.1%
27	677	3.1%
28	667	3.0%
Other values (47)	13286	60.3%

Value	Count	Frequency (%)
18	2058	9.3%
19	289	1.3%
20	359	1.6%
21	348	1.6%
22	387	1.8%
23	503	2.3%
24	453	2.1%
25	569	2.6%
26	544	2.5%
27	677	3.1%

Value	Count	Frequency (%)
75	12	0.1%
73	4	< 0.1%
72	12	0.1%
71	8	< 0.1%
70	9	< 0.1%
69	4	< 0.1%
68	10	< 0.1%
67	9	< 0.1%
66	28	0.1%
65	32	0.1%

Gender
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Female	11105
Male	10611
Other	333

Length

Max length	6
Median length	6
Mean length	5.0224046
Min length	4

Characters and Unicode

Total characters	110739
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Male
3rd row	Male
4th row	Male
5th row	Male

Common Values

Value	Count	Frequency (%)
Female	11105	50.4%
Male	10611	48.1%
Other	333	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	11105	50.4%
male	10611	48.1%
other	333	1.5%

Most occurring characters

Value	Count	Frequency (%)
e	33154	29.9%
a	21716	19.6%
l	21716	19.6%
F	11105	10.0%
m	11105	10.0%
M	10611	9.6%
O	333	0.3%
t	333	0.3%
h	333	0.3%
r	333	0.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	110739	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	33154	29.9%
a	21716	19.6%
l	21716	19.6%
F	11105	10.0%
m	11105	10.0%
M	10611	9.6%
O	333	0.3%
t	333	0.3%
h	333	0.3%
r	333	0.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	110739	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	33154	29.9%
a	21716	19.6%
l	21716	19.6%
F	11105	10.0%
m	11105	10.0%
M	10611	9.6%
O	333	0.3%
t	333	0.3%
h	333	0.3%
r	333	0.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	110739	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	33154	29.9%
a	21716	19.6%
l	21716	19.6%
F	11105	10.0%
m	11105	10.0%
M	10611	9.6%
O	333	0.3%
t	333	0.3%
h	333	0.3%
r	333	0.3%

City
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Istanbul	5686
Ankara	3157
Izmir	2672
Bursa	2217
Adana	1704
Other values (5)	6613

Length

Max length	9
Median length	8
Mean length	6.6083723
Min length	5

Characters and Unicode

Total characters	145708
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Konya
2nd row	Izmir
3rd row	Adana
4th row	Istanbul
5th row	Ankara

Common Values

Value	Count	Frequency (%)
Istanbul	5686	25.8%
Ankara	3157	14.3%
Izmir	2672	12.1%
Bursa	2217	10.1%
Adana	1704	7.7%
Antalya	1620	7.3%
Gaziantep	1532	6.9%
Konya	1437	6.5%
Kayseri	1108	5.0%
Eskisehir	916	4.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
istanbul	5686	25.8%
ankara	3157	14.3%
izmir	2672	12.1%
bursa	2217	10.1%
adana	1704	7.7%
antalya	1620	7.3%
gaziantep	1532	6.9%
konya	1437	6.5%
kayseri	1108	5.0%
eskisehir	916	4.2%

Most occurring characters

Value	Count	Frequency (%)
a	26474	18.2%
n	15136	10.4%
s	10843	7.4%
r	10070	6.9%
t	8838	6.1%
I	8358	5.7%
u	7903	5.4%
l	7306	5.0%
i	7144	4.9%
A	6481	4.4%
Other values (14)	37155	25.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	145708	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	26474	18.2%
n	15136	10.4%
s	10843	7.4%
r	10070	6.9%
t	8838	6.1%
I	8358	5.7%
u	7903	5.4%
l	7306	5.0%
i	7144	4.9%
A	6481	4.4%
Other values (14)	37155	25.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	145708	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	26474	18.2%
n	15136	10.4%
s	10843	7.4%
r	10070	6.9%
t	8838	6.1%
I	8358	5.7%
u	7903	5.4%
l	7306	5.0%
i	7144	4.9%
A	6481	4.4%
Other values (14)	37155	25.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	145708	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	26474	18.2%
n	15136	10.4%
s	10843	7.4%
r	10070	6.9%
t	8838	6.1%
I	8358	5.7%
u	7903	5.4%
l	7306	5.0%
i	7144	4.9%
A	6481	4.4%
Other values (14)	37155	25.5%

Product_Category
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Sports	2915
Beauty	2833
Books	2822
Food	2722
Toys	2700
Other values (3)	8057

Length

Max length	13
Median length	11
Mean length	6.9646242
Min length	4

Characters and Unicode

Total characters	153563
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Books
2nd row	Food
3rd row	Beauty
4th row	Food
5th row	Toys

Common Values

Value	Count	Frequency (%)
Sports	2915	13.2%
Beauty	2833	12.8%
Books	2822	12.8%
Food	2722	12.3%
Toys	2700	12.2%
Electronics	2698	12.2%
Home & Garden	2681	12.2%
Fashion	2678	12.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sports	2915	10.6%
beauty	2833	10.3%
books	2822	10.3%
food	2722	9.9%
toys	2700	9.9%
electronics	2698	9.8%
home	2681	9.8%
	2681	9.8%
garden	2681	9.8%
fashion	2678	9.8%

Most occurring characters

Value	Count	Frequency (%)
o	24760	16.1%
s	13813	9.0%
e	10893	7.1%
t	8446	5.5%
r	8294	5.4%
a	8192	5.3%
n	8057	5.2%
B	5655	3.7%
y	5533	3.6%
d	5403	3.5%
Other values (16)	54517	35.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	153563	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	24760	16.1%
s	13813	9.0%
e	10893	7.1%
t	8446	5.5%
r	8294	5.4%
a	8192	5.3%
n	8057	5.2%
B	5655	3.7%
y	5533	3.6%
d	5403	3.5%
Other values (16)	54517	35.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	153563	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	24760	16.1%
s	13813	9.0%
e	10893	7.1%
t	8446	5.5%
r	8294	5.4%
a	8192	5.3%
n	8057	5.2%
B	5655	3.7%
y	5533	3.6%
d	5403	3.5%
Other values (16)	54517	35.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	153563	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	24760	16.1%
s	13813	9.0%
e	10893	7.1%
t	8446	5.5%
r	8294	5.4%
a	8192	5.3%
n	8057	5.2%
B	5655	3.7%
y	5533	3.6%
d	5403	3.5%
Other values (16)	54517	35.5%

Unit_Price
Real number (ℝ)

High correlation

Distinct	18299
Distinct (%)	83.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	449.70051

Minimum	5.05
Maximum	7900.01
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	344.5 KiB

Quantile statistics

Minimum	5.05
5-th percentile	27.244
Q1	74.05
median	177.11
Q3	499.36
95-th percentile	1794.946
Maximum	7900.01
Range	7894.96
Interquartile range (IQR)	425.31

Descriptive statistics

Standard deviation	720.09111
Coefficient of variation (CV)	1.6012682
Kurtosis	17.247287
Mean	449.70051
Median Absolute Deviation (MAD)	129.58
Skewness	3.6071037
Sum	9915446.5
Variance	518531.21
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56.63	8	< 0.1%
34.71	5	< 0.1%
46.78	5	< 0.1%
52.33	5	< 0.1%
60.18	5	< 0.1%
67.37	5	< 0.1%
23.73	5	< 0.1%
39.42	5	< 0.1%
83.63	5	< 0.1%
24.55	5	< 0.1%
Other values (18289)	21996	99.8%

Value	Count	Frequency (%)
5.05	1	< 0.1%
5.18	1	< 0.1%
5.78	1	< 0.1%
6.3	2	< 0.1%
6.35	1	< 0.1%
6.64	1	< 0.1%
6.65	1	< 0.1%
6.83	1	< 0.1%
7.58	1	< 0.1%
7.59	1	< 0.1%

Value	Count	Frequency (%)
7900.01	1	< 0.1%
7570.41	1	< 0.1%
7440.42	1	< 0.1%
7272.85	1	< 0.1%
7159.45	1	< 0.1%
7061.34	1	< 0.1%
6935.92	1	< 0.1%
6810.27	1	< 0.1%
6766.07	1	< 0.1%
6759.75	1	< 0.1%

Quantity
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

1	5641
2	4431
5	4027
3	3997
4	3953

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	22049
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	1
3rd row	2
4th row	3
5th row	2

Common Values

Value	Count	Frequency (%)
1	5641	25.6%
2	4431	20.1%
5	4027	18.3%
3	3997	18.1%
4	3953	17.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	5641	25.6%
2	4431	20.1%
5	4027	18.3%
3	3997	18.1%
4	3953	17.9%

Most occurring characters

Value	Count	Frequency (%)
1	5641	25.6%
2	4431	20.1%
5	4027	18.3%
3	3997	18.1%
4	3953	17.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	22049	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	5641	25.6%
2	4431	20.1%
5	4027	18.3%
3	3997	18.1%
4	3953	17.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	22049	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	5641	25.6%
2	4431	20.1%
5	4027	18.3%
3	3997	18.1%
4	3953	17.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	22049	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	5641	25.6%
2	4431	20.1%
5	4027	18.3%
3	3997	18.1%
4	3953	17.9%

Discount_Amount
Real number (ℝ)

Zeros

Distinct	6463
Distinct (%)	29.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59.598256

Minimum	0
Maximum	6538.29
Zeros	14046
Zeros (%)	63.7%
Negative	0
Negative (%)	0.0%
Memory size	344.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	25.08
95-th percentile	308.892
Maximum	6538.29
Range	6538.29
Interquartile range (IQR)	25.08

Descriptive statistics

Standard deviation	216.62132
Coefficient of variation (CV)	3.6346922
Kurtosis	144.23264
Mean	59.598256
Median Absolute Deviation (MAD)	0
Skewness	9.395494
Sum	1314081.9
Variance	46924.795
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14046	63.7%
3.84	7	< 0.1%
7.88	6	< 0.1%
8.39	6	< 0.1%
18.95	6	< 0.1%
3.72	5	< 0.1%
7.14	5	< 0.1%
9.44	5	< 0.1%
8.44	5	< 0.1%
4.93	5	< 0.1%
Other values (6453)	7953	36.1%

Value	Count	Frequency (%)
0	14046	63.7%
0.62	1	< 0.1%
0.8	1	< 0.1%
0.86	1	< 0.1%
0.89	1	< 0.1%
0.97	1	< 0.1%
0.98	1	< 0.1%
1.01	1	< 0.1%
1.02	1	< 0.1%
1.03	1	< 0.1%

Value	Count	Frequency (%)
6538.29	1	< 0.1%
5158.85	1	< 0.1%
5109.32	1	< 0.1%
4697.85	1	< 0.1%
4378.57	1	< 0.1%
4354.49	1	< 0.1%
4252.42	1	< 0.1%
3754.74	1	< 0.1%
3738.19	1	< 0.1%
3504.47	1	< 0.1%

Total_Amount
Real number (ℝ)

High correlation

Distinct	20098
Distinct (%)	91.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1210.6942

Minimum	6.21
Maximum	37852.05
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	344.5 KiB

Quantile statistics

Minimum	6.21
5-th percentile	47.316
Q1	159.8
median	429.92
Q3	1199.06
95-th percentile	5031.35
Maximum	37852.05
Range	37845.84
Interquartile range (IQR)	1039.26

Descriptive statistics

Standard deviation	2265.7556
Coefficient of variation (CV)	1.8714515
Kurtosis	31.510164
Mean	1210.6942
Median Absolute Deviation (MAD)	329.94
Skewness	4.6772284
Sum	26694597
Variance	5133648.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
172.98	5	< 0.1%
192.69	4	< 0.1%
141.88	4	< 0.1%
40.18	4	< 0.1%
120.18	4	< 0.1%
57.81	4	< 0.1%
77.56	4	< 0.1%
128.78	4	< 0.1%
48.93	4	< 0.1%
36.92	4	< 0.1%
Other values (20088)	22008	99.8%

Value	Count	Frequency (%)
6.21	1	< 0.1%
6.3	1	< 0.1%
7	1	< 0.1%
7.59	1	< 0.1%
7.87	1	< 0.1%
7.89	1	< 0.1%
7.94	1	< 0.1%
8.33	1	< 0.1%
8.77	1	< 0.1%
8.92	1	< 0.1%

Value	Count	Frequency (%)
37852.05	1	< 0.1%
32823.53	1	< 0.1%
29045.35	1	< 0.1%
28640.75	1	< 0.1%
28638.86	1	< 0.1%
26363.5	1	< 0.1%
26005.25	1	< 0.1%
25579.4	1	< 0.1%
25562.1	1	< 0.1%
25061.75	1	< 0.1%

Payment_Method
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

Credit Card	8813
Debit Card	5586
Digital Wallet	4241
Bank Transfer	2273
Cash on Delivery	1136

Length

Max length	16
Median length	14
Mean length	11.787473
Min length	10

Characters and Unicode

Total characters	259902
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Debit Card
2nd row	Credit Card
3rd row	Credit Card
4th row	Credit Card
5th row	Digital Wallet

Common Values

Value	Count	Frequency (%)
Credit Card	8813	40.0%
Debit Card	5586	25.3%
Digital Wallet	4241	19.2%
Bank Transfer	2273	10.3%
Cash on Delivery	1136	5.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
card	14399	31.8%
credit	8813	19.5%
debit	5586	12.3%
digital	4241	9.4%
wallet	4241	9.4%
bank	2273	5.0%
transfer	2273	5.0%
cash	1136	2.5%
on	1136	2.5%
delivery	1136	2.5%

Most occurring characters

Value	Count	Frequency (%)
r	28894	11.1%
a	28563	11.0%
C	24348	9.4%
i	24017	9.2%
d	23212	8.9%
e	23185	8.9%
	23185	8.9%
t	22881	8.8%
l	13859	5.3%
D	10963	4.2%
Other values (13)	36795	14.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	259902	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	28894	11.1%
a	28563	11.0%
C	24348	9.4%
i	24017	9.2%
d	23212	8.9%
e	23185	8.9%
	23185	8.9%
t	22881	8.8%
l	13859	5.3%
D	10963	4.2%
Other values (13)	36795	14.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	259902	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	28894	11.1%
a	28563	11.0%
C	24348	9.4%
i	24017	9.2%
d	23212	8.9%
e	23185	8.9%
	23185	8.9%
t	22881	8.8%
l	13859	5.3%
D	10963	4.2%
Other values (13)	36795	14.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	259902	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	28894	11.1%
a	28563	11.0%
C	24348	9.4%
i	24017	9.2%
d	23212	8.9%
e	23185	8.9%
	23185	8.9%
t	22881	8.8%
l	13859	5.3%
D	10963	4.2%
Other values (13)	36795	14.2%

Device_Type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Mobile	12338
Desktop	7556
Tablet	2155

Length

Max length	7
Median length	6
Mean length	6.3426913
Min length	6

Characters and Unicode

Total characters	139850
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Desktop
2nd row	Desktop
3rd row	Desktop
4th row	Mobile
5th row	Tablet

Common Values

Value	Count	Frequency (%)
Mobile	12338	56.0%
Desktop	7556	34.3%
Tablet	2155	9.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mobile	12338	56.0%
desktop	7556	34.3%
tablet	2155	9.8%

Most occurring characters

Value	Count	Frequency (%)
e	22049	15.8%
o	19894	14.2%
b	14493	10.4%
l	14493	10.4%
M	12338	8.8%
i	12338	8.8%
t	9711	6.9%
D	7556	5.4%
s	7556	5.4%
k	7556	5.4%
Other values (3)	11866	8.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	139850	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	22049	15.8%
o	19894	14.2%
b	14493	10.4%
l	14493	10.4%
M	12338	8.8%
i	12338	8.8%
t	9711	6.9%
D	7556	5.4%
s	7556	5.4%
k	7556	5.4%
Other values (3)	11866	8.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	139850	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	22049	15.8%
o	19894	14.2%
b	14493	10.4%
l	14493	10.4%
M	12338	8.8%
i	12338	8.8%
t	9711	6.9%
D	7556	5.4%
s	7556	5.4%
k	7556	5.4%
Other values (3)	11866	8.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	139850	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	22049	15.8%
o	19894	14.2%
b	14493	10.4%
l	14493	10.4%
M	12338	8.8%
i	12338	8.8%
t	9711	6.9%
D	7556	5.4%
s	7556	5.4%
k	7556	5.4%
Other values (3)	11866	8.5%

Session_Duration_Minutes
Real number (ℝ)

Distinct	58
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.544197

Minimum	1
Maximum	73
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	344.5 KiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	12
median	14
Q3	17
95-th percentile	21
Maximum	73
Range	72
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	4.8625669
Coefficient of variation (CV)	0.33433038
Kurtosis	8.8778464
Mean	14.544197
Median Absolute Deviation (MAD)	2
Skewness	1.4986519
Sum	320685
Variance	23.644556
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	2576	11.7%
15	2551	11.6%
16	2227	10.1%
13	2198	10.0%
12	1868	8.5%
17	1851	8.4%
11	1359	6.2%
18	1333	6.0%
10	982	4.5%
19	856	3.9%
Other values (48)	4248	19.3%

Value	Count	Frequency (%)
1	43	0.2%
2	67	0.3%
3	122	0.6%
4	170	0.8%
5	208	0.9%
6	243	1.1%
7	334	1.5%
8	462	2.1%
9	663	3.0%
10	982	4.5%

Value	Count	Frequency (%)
73	1	< 0.1%
64	1	< 0.1%
57	1	< 0.1%
55	2	< 0.1%
54	2	< 0.1%
53	3	< 0.1%
52	2	< 0.1%
51	2	< 0.1%
50	1	< 0.1%
49	3	< 0.1%

Pages_Viewed
Real number (ℝ)

Distinct	22
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.9988208

Minimum	1
Maximum	24
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	344.5 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	7
median	9
Q3	11
95-th percentile	13
Maximum	24
Range	23
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.3942243
Coefficient of variation (CV)	0.26605978
Kurtosis	0.21997506
Mean	8.9988208
Median Absolute Deviation (MAD)	2
Skewness	0.11137
Sum	198415
Variance	5.7323099
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
9	3673	16.7%
10	3447	15.6%
8	3435	15.6%
7	2615	11.9%
11	2520	11.4%
6	1696	7.7%
12	1607	7.3%
5	903	4.1%
13	882	4.0%
4	409	1.9%
Other values (12)	862	3.9%

Value	Count	Frequency (%)
1	14	0.1%
2	33	0.1%
3	151	0.7%
4	409	1.9%
5	903	4.1%
6	1696	7.7%
7	2615	11.9%
8	3435	15.6%
9	3673	16.7%
10	3447	15.6%

Value	Count	Frequency (%)
24	1	< 0.1%
22	1	< 0.1%
20	1	< 0.1%
19	4	< 0.1%
18	8	< 0.1%
17	25	0.1%
16	77	0.3%
15	172	0.8%
14	375	1.7%
13	882	4.0%

Is_Returning_Customer
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

True	18029
False	4020

Value	Count	Frequency (%)
True	18029	81.8%
False	4020	18.2%

Delivery_Time_Days
Real number (ℝ)

Distinct	25
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5021089

Minimum	1
Maximum	25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	344.5 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	4
median	6
Q3	8
95-th percentile	13
Maximum	25
Range	24
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.4833222
Coefficient of variation (CV)	0.53572191
Kurtosis	1.8473909
Mean	6.5021089
Median Absolute Deviation (MAD)	2
Skewness	1.1276282
Sum	143365
Variance	12.133534
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
5	2899	13.1%
4	2886	13.1%
6	2673	12.1%
3	2549	11.6%
7	2197	10.0%
8	1750	7.9%
2	1449	6.6%
9	1423	6.5%
10	1024	4.6%
11	947	4.3%
Other values (15)	2252	10.2%

Value	Count	Frequency (%)
1	301	1.4%
2	1449	6.6%
3	2549	11.6%
4	2886	13.1%
5	2899	13.1%
6	2673	12.1%
7	2197	10.0%
8	1750	7.9%
9	1423	6.5%
10	1024	4.6%

Value	Count	Frequency (%)
25	10	< 0.1%
24	12	0.1%
23	14	0.1%
22	16	0.1%
21	15	0.1%
20	44	0.2%
19	37	0.2%
18	74	0.3%
17	94	0.4%
16	97	0.4%

Customer_Rating
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

5	8093
4	7608
3	3417
2	1916
1	1015

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	22049
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	1
3rd row	5
4th row	4
5th row	4

Common Values

Value	Count	Frequency (%)
5	8093	36.7%
4	7608	34.5%
3	3417	15.5%
2	1916	8.7%
1	1015	4.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	8093	36.7%
4	7608	34.5%
3	3417	15.5%
2	1916	8.7%
1	1015	4.6%

Most occurring characters

Value	Count	Frequency (%)
5	8093	36.7%
4	7608	34.5%
3	3417	15.5%
2	1916	8.7%
1	1015	4.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	22049	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	8093	36.7%
4	7608	34.5%
3	3417	15.5%
2	1916	8.7%
1	1015	4.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	22049	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	8093	36.7%
4	7608	34.5%
3	3417	15.5%
2	1916	8.7%
1	1015	4.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	22049	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	8093	36.7%
4	7608	34.5%
3	3417	15.5%
2	1916	8.7%
1	1015	4.6%

	Age	City	Customer_Rating	Delivery_Time_Days	Device_Type	Discount_Amount	Gender	Is_Returning_Customer	Pages_Viewed	Payment_Method	Product_Category	Quantity	Session_Duration_Minutes	Total_Amount	Unit_Price
Age	1.000	0.043	0.000	-0.002	0.013	-0.002	0.038	0.013	-0.008	0.000	0.012	0.005	0.012	-0.003	-0.003
City	0.043	1.000	0.000	0.000	0.000	0.000	0.030	0.023	0.010	0.000	0.000	0.006	0.004	0.001	0.000
Customer_Rating	0.000	0.000	1.000	0.010	0.006	0.000	0.011	0.000	0.000	0.002	0.006	0.000	0.000	0.000	0.009
Delivery_Time_Days	-0.002	0.000	0.010	1.000	0.000	0.002	0.011	0.017	0.007	0.010	0.011	0.000	0.004	-0.007	-0.006
Device_Type	0.013	0.000	0.006	0.000	1.000	0.000	0.007	0.004	0.000	0.015	0.000	0.007	0.012	0.000	0.016
Discount_Amount	-0.002	0.000	0.000	0.002	0.000	1.000	0.000	0.014	-0.002	0.013	0.104	0.050	0.008	0.111	0.141
Gender	0.038	0.030	0.011	0.011	0.007	0.000	1.000	0.000	0.000	0.000	0.007	0.007	0.000	0.037	0.006
Is_Returning_Customer	0.013	0.023	0.000	0.017	0.004	0.014	0.000	1.000	0.046	0.000	0.000	0.075	0.167	0.013	0.000
Pages_Viewed	-0.008	0.010	0.000	0.007	0.000	-0.002	0.000	0.046	1.000	0.007	0.000	0.020	0.013	0.003	0.002
Payment_Method	0.000	0.000	0.002	0.010	0.015	0.013	0.000	0.000	0.007	1.000	0.000	0.005	0.010	0.011	0.000
Product_Category	0.012	0.000	0.006	0.011	0.000	0.104	0.007	0.000	0.000	0.000	1.000	0.000	0.000	0.209	0.290
Quantity	0.005	0.006	0.000	0.000	0.007	0.050	0.007	0.075	0.020	0.005	0.000	1.000	0.068	0.109	0.000
Session_Duration_Minutes	0.012	0.004	0.000	0.004	0.012	0.008	0.000	0.167	0.013	0.010	0.000	0.068	1.000	-0.007	-0.013
Total_Amount	-0.003	0.001	0.000	-0.007	0.000	0.111	0.037	0.013	0.003	0.011	0.209	0.109	-0.007	1.000	0.901
Unit_Price	-0.003	0.000	0.009	-0.006	0.016	0.141	0.006	0.000	0.002	0.000	0.290	0.000	-0.013	0.901	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	Order_ID	Customer_ID	Date	Age	Gender	City	Product_Category	Unit_Price	Quantity	Discount_Amount	Total_Amount	Payment_Method	Device_Type	Session_Duration_Minutes	Pages_Viewed	Is_Returning_Customer	Delivery_Time_Days	Customer_Rating
22048	ORD_000902	CUST_00902	2024-03-26	30	Female	Konya	Books	84.30	4	21.72	315.48	Debit Card	Desktop	8	9	True	5	5
22043	ORD_003209	CUST_03209	2024-03-26	45	Male	Izmir	Food	50.69	1	11.72	38.97	Credit Card	Desktop	5	6	False	2	1
22038	ORD_001404	CUST_01404	2024-03-26	43	Male	Adana	Beauty	120.67	2	7.88	233.46	Credit Card	Desktop	10	8	True	4	5
22039	ORD_000463	CUST_00463	2024-03-26	26	Male	Istanbul	Food	19.84	3	0.00	59.52	Credit Card	Mobile	11	10	False	6	4
22040	ORD_002934	CUST_02934	2024-03-26	46	Male	Ankara	Toys	60.12	2	12.95	107.29	Digital Wallet	Tablet	22	7	True	6	4
22042	ORD_001360	CUST_01360	2024-03-26	37	Female	Bursa	Toys	99.46	1	0.00	99.46	Bank Transfer	Desktop	5	9	False	4	1
22041	ORD_000841	CUST_00841	2024-03-26	34	Other	Istanbul	Books	69.79	4	0.00	279.16	Bank Transfer	Desktop	10	10	False	11	5
22044	ORD_001048	CUST_01048	2024-03-26	18	Female	Izmir	Beauty	130.35	1	27.30	103.05	Bank Transfer	Mobile	17	10	False	9	1
22045	ORD_001051	CUST_01051	2024-03-26	27	Male	Adana	Beauty	71.55	1	0.00	71.55	Debit Card	Mobile	13	9	True	6	4
22046	ORD_003543	CUST_03543	2024-03-26	45	Female	Antalya	Food	39.38	1	5.27	34.11	Digital Wallet	Mobile	38	10	True	5	4

	Order_ID	Customer_ID	Date	Age	Gender	City	Product_Category	Unit_Price	Quantity	Discount_Amount	Total_Amount	Payment_Method	Device_Type	Session_Duration_Minutes	Pages_Viewed	Is_Returning_Customer	Delivery_Time_Days	Customer_Rating
13963	ORD_004116-1	CUST_04116	2023-01-01	30	Female	Istanbul	Food	33.77	4	17.46	117.62	Bank Transfer	Mobile	15	7	False	3	4
50	ORD_000018-1	CUST_00018	2023-01-01	38	Female	Bursa	Books	20.84	5	0.00	104.20	Bank Transfer	Mobile	17	10	True	5	4
1149	ORD_000355-1	CUST_00355	2023-01-01	34	Female	Ankara	Electronics	1254.26	1	0.00	1254.26	Digital Wallet	Mobile	14	6	True	10	5
3681	ORD_001070-1	CUST_01070	2023-01-01	39	Male	Istanbul	Books	89.89	2	0.00	179.78	Debit Card	Mobile	17	11	True	2	4
3686	ORD_001073-1	CUST_01073	2023-01-01	35	Male	Eskisehir	Toys	72.69	5	0.00	363.45	Credit Card	Mobile	16	8	False	8	1
15966	ORD_004690-1	CUST_04690	2023-01-01	29	Female	Izmir	Electronics	834.80	2	0.00	1669.60	Cash on Delivery	Mobile	14	11	True	6	5
1163	ORD_000359-1	CUST_00359	2023-01-01	38	Female	Ankara	Fashion	107.95	1	0.00	107.95	Credit Card	Tablet	14	5	True	5	4
8588	ORD_002510-1	CUST_02510	2023-01-01	19	Female	Istanbul	Home & Garden	158.85	2	0.00	317.70	Digital Wallet	Mobile	14	7	False	7	4
3016	ORD_000894-1	CUST_00894	2023-01-01	49	Male	Ankara	Beauty	194.32	3	53.05	529.91	Debit Card	Mobile	12	4	False	3	4
4843	ORD_001397-1	CUST_01397	2023-01-01	18	Male	Antalya	Fashion	51.82	1	0.00	51.82	Cash on Delivery	Mobile	12	11	True	4	3

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category